80 Crystal Reports 100 SELECT object_name, owner, object_type FROM sys.dba_objects WHERE 101 SELECT object_name, owner, object_type FROM sys.all_objects WHERE 102 AND (owner NOT LIKE 'SYS%%' AND object_type = 'TABLE' OR object_type <> 'TABLE') 103 AND (owner LIKE 'SYS%%' AND object_type = 'TABLE' OR object_type <> 'TABLE') 104 256 105 8 106 _ 107 owner LIKE 108 object_name LIKE 109 object_type IN 110 SELECT COUNT(*) FROM sys.dba_objects WHERE 111 SELECT COUNT(*) FROM sys.all_objects WHERE 112 ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS' 113 SELECT 114 SELECT \n 115 Login error 116 Database Server must be version 7.0 or later. 117 Can not link from stored procedure. 118 Attempting to use closed cursor. 200 3 201 4 202 5 203 7 204 8 205 9 206 10 207 11 300 = Equal Join 301 =(+) Left Outer Join 302 (+)= Right Outer Join 303 > Greater Join 304 < Less Join 305 >= Greater Or Equal 306 <= Less Or Equal 307 != Not Equal Join 400 = 401 = 402 = 403 = 404 = 405 = 406 = 407 > 408 < 409 >= 410 <= 411 != 504 Warning: %ld records will be returned.\nProceed? 505 Estimating Results from Server 506 Warning: %d table names will be returned.\nProceed? 507 Allow Reporting On 508 Incorrect table name. If you are converting from another database, please use 'Set Location' to point to the correct table. 509 You have either no permission to view the selected object or the table name is incorrect. If you are converting from another database, please use 'Set Location' to point to the correct table. 1000 CONVERT\n11\n2\n11\n11\n8 1001 RAWTOHEX\n11\n1\n255\n0 1002 ROWIDTOCHAR\n11\n1\n255\n0 1003 TO_CHAR\n11\n1\n255\n8 1004 TO_DATE\n15\n1\n11\n8 1005 TO_MULTI_BYTE\n11\n1\n11\n0 1006 TO_NUMBER\n6\n1\n11\n8 1007 TO_SINGLE_BYTE\n11\n1\n11\n0 1008 NLS_CHARSET_ID\n6\n1\n11\n0 1009 NLS_CHARSET_NAME\n11\n1\n6\n0 1200 ABS\n6\n1\n6\n0 1201 ACOS\n6\n1\n6\n0 1202 ASIN\n6\n1\n6\n0 1203 ATAN\n6\n1\n6\n0 1204 ATAN2\n6\n2\n6\n6\n0 1205 CEIL\n6\n1\n6\n0 1206 COS\n6\n1\n6\n0 1207 COSH\n6\n1\n6\n0 1208 EXP\n6\n1\n6\n0 1209 FLOOR\n6\n1\n6\n0 1210 LN\n6\n1\n6\n0 1211 LOG\n6\n2\n6\n6\n0 1212 MOD\n6\n2\n6\n6\n0 1213 POWER\n6\n2\n6\n6\n0 1214 ROUND\n6\n1\n6\n24 1215 SIGN\n6\n1\n6\n0 1216 SIN\n6\n1\n6\n0 1217 SINH\n6\n1\n6\n0 1218 SQRT\n6\n1\n6\n0 1219 TAN\n6\n1\n6\n0 1220 TANH\n6\n1\n6\n0 1221 TRUNC\n6\n1\n6\n24 1400 ASCII\n6\n1\n11\n0 1401 CHR\n11\n1\n6\n0 1402 CONCAT\n11\n2\n11\n11\n0 1403 INITCAP\n11\n1\n11\n0 1404 INSTR\n6\n2\n11\n11\n8 1405 INSTRB\n6\n2\n11\n11\n8 1406 LENGTH\n6\n1\n11\n0 1407 LENGTHB\n6\n1\n11\n0 1408 LOWER\n11\n1\n11\n0 1409 LPAD\n11\n2\n11\n6\n8 1410 LTRIM\n11\n1\n11\n8 1411 NLS_INITCAP\n11\n1\n11\n8 1412 NLS_LOWER\n11\n1\n11\n8 1413 NLS_UPPER\n11\n1\n11\n8 1414 NLSSORT\n11\n1\n11\n8 1415 REPLACE\n11\n2\n11\n11\n8 1416 RPAD\n11\n2\n11\n6\n8 1417 RTRIM\n11\n1\n11\n8 1418 SOUNDEX\n11\n1\n11\n0 1419 SUBSTR\n11\n2\n11\n6\n8 1420 SUBSTRB\n11\n2\n11\n6\n8 1421 TRANSLATE\n11\n3\n11\n11\n11\n0 1422 UPPER\n11\n1\n11\n0 1600 DUMP\n11\n1\n255\n8 1601 GREATEST\n250\n1\n255\n8 1602 LEAST\n250\n1\n255\n8 1603 NVL\n250\n2\n255\n255\n0 1604 UID\n6\n0\n4 1605 USER\n11\n0\n4 1606 USERENV\n11\n1\n11\n0 1607 VSIZE\n6\n1\n255\n0 1608 NLS_CHARSET_DECL_LEN\n6\n2\n6\n6\n0 1800 ADD_MONTHS\n15\n2\n255\n6\n0 1801 LAST_DAY\n15\n1\n255\n0 1802 MONTHS_BETWEEN\n6\n2\n255\n255\n0 1803 NEW_TIME\n15\n3\n255\n11\n11\n0 1804 NEXT_DAY\n15\n2\n255\n11\n0 1805 ROUND\n15\n1\n15\n24 1806 SYSDATE\n15\n0\n4 1807 TRUNC\n15\n1\n15\n24 2000 AVG\n6\n1\n11\n9 2001 COUNT\n6\n1\n11\n9 2002 MAX\n6\n1\n11\n9 2003 MIN\n6\n1\n11\n9 2004 STADDEV\n6\n1\n11\n9 2005 SUM\n6\n1\n11\n9 2006 VARIANCE\n6\n1\n11\n9 3000 Zero 3001 JAN 3002 FEB 3003 MAR 3004 APR 3005 MAY 3006 JUN 3007 JUL 3008 AUG 3009 SEP 3010 OCT 3011 NOV 3012 DEC